Plotting murder by year

Among selected precincts (based on initial discussions)

  • Excluding 114 (Astoria)

Among likely control precincts

Among all precincts

Slopes of murder across year for each precinct

  • Find similar slopes to “case_avg”
    PCT slope
    79 -0.6415584
    75 -0.6064935
    83 -0.5909091
    81 -0.5727273
    71 -0.5467532
    67 -0.5142857
    73 -0.5038961
    103 -0.4363636
    113 -0.3116883
    105 -0.2688312
    70 -0.2389610
    32 -0.2155844
    60 -0.2064935
    72 -0.2012987
    30 -0.1870130
    63 -0.1857143
    46 -0.1805195
    61 -0.1779221
    28 -0.1701299
    108 -0.1350649
    52 -0.1311688
    106 -0.1272727
    7 -0.1233766
    26 -0.1220779
    23 -0.1207792
    cases_avg -0.1194805
    110 -0.1181818
    69 -0.1142857
    104 -0.1142857
    112 -0.1116883
    50 -0.1090909
    10 -0.1077922
    109 -0.1051948
    101 -0.0831169
    6 -0.0792208
    107 -0.0779221
    90 -0.0675325
    114 -0.0610390
    33 -0.0584416
    44 -0.0584416
    42 -0.0545455
    94 -0.0532468
    45 -0.0519481
    62 -0.0519481
    66 -0.0467532
    13 -0.0311688
    76 -0.0298701
    19 -0.0207792
    100 -0.0207792
    24 -0.0168831
    20 -0.0077922
    123 -0.0051948
    68 0.0025974
    102 0.0077922
    41 0.0090909
    25 0.0129870
    40 0.0142857
    18 0.0207792
    34 0.0233766
    111 0.0337662
    115 0.0337662
    9 0.0337662
    84 0.0415584
    17 0.0428571
    1 0.0558442
    48 0.0831169
    5 0.1116883
    14 0.1714286

Plotting shootings by year

Among selected precincts (based on initial discussions)

  • Excluding 114 (Astoria)

Among likely controls

Among all precincts

Slopes of shootings across year for each precinct

  • Find similar slopes to “case_avg”
    PCT slope
    79 -3.1768382
    67 -2.9408261
    73 -2.8964945
    75 -2.7065716
    81 -2.2624744
    113 -2.1291866
    83 -1.8559711
    71 -1.6799141
    103 -1.1371936
    70 -1.1279172
    105 -0.9938483
    cases_avg -0.9109787
    101 -0.8298994
    41 -0.7710185
    32 -0.7219022
    52 -0.6909481
    63 -0.6427107
    60 -0.6121473
    30 -0.4612831
    23 -0.4539596
    42 -0.4199785
    40 -0.4083586
    90 -0.3843375
    69 -0.3723269
    61 -0.3480129
    33 -0.3303388
    106 -0.2635485
    10 -0.2498779
    28 -0.2026169
    76 -0.1703935
    100 -0.1554536
    26 -0.1489112
    46 -0.1445171
    24 -0.1412948
    104 -0.1365101
    112 -0.1252807
    62 -0.1194219
    110 -0.1162972
    109 -0.1142467
    6 -0.1098526
    66 -0.0682551
    45 -0.0503857
    123 -0.0436481
    115 -0.0369105
    13 -0.0165023
    68 -0.0105458
    17 0.0130847
    50 0.0197246
    1 0.0235329
    94 0.0266576
    72 0.0342740
    7 0.0405234
    107 0.0476516
    48 0.0510692
    84 0.0580998
    25 0.0714774
    9 0.0844644
    111 0.0901279
    5 0.1055561
    44 0.1064349
    20 0.1201055
    18 0.1324089
    19 0.1836735
    114 0.1934381
    108 0.1980275
    102 0.2875696
    14 0.3834586
    34 1.0368128